This procedure affects all subtotals and grand totals in the PivotTable list.
To exclude hidden data, select Visible items only.
Notes
This setting affects data hidden by filtering row and column fields; data hidden by using filter fields is always excluded from totals.